Problem Note 46563: WARNING: SQL generation was not performed because the RENAME statement, data set option, or LIBNAME option is not supported
 |  |  |  |
The following message might appear in the SAS log file when you sort a DBMS table using the SORT procedure in SAS® 9.3:
WARNING: SQL generation was not performed because the RENAME statement,
data set option, or LIBNAME option is not supported.
In SAS 9.3, the default behavior of SAS has been changed to take advantage of in-database processing. The default value for the SQLGENERATION option is DBMS. The warning message occurs when SQL generation is not available. However, the SORT procedure sorts the table successfully.
To prevent the warning message from appearing in the SAS log,
disable in-database processing by setting the value of the SQLGENERATION
option to NONE.
Alternatively, disable in-database processing
for a particular engine and/or procedure by setting the
SQLGENERATION system option appropriately.
The SQLGENERATION option can be set as a
LIBNAME option
or as a
SAS system option.
In a future release, the message will be printed as a NOTE.
An additional message will clarify that PROC SORT has sorted the table
successfully.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | 64-bit Enabled AIX | 9.3 TS1M0 | 9.3 TS1M2 |
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.3 TS1M2 | ||
| HP-UX IPF | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Linux | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Linux for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Solaris for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||